May 4, 2015 at 8:27 am
Hi
I have this requirement.
I have excel. I connected to PowerPivot model.
I want to key in state code and product Category name and hit submit/refresh button, the data should be refreshed based on the parameters and ready.
I will try to pull the columns/fields from field list to pivot table. the filtered data should appear as per the parameters I have above.
I don't want to bring whole data set which is of 10 million records. I want to restrict data at the run time based on user input and bring that data alone to PowerPivot.
I am okay for PowerQuery or SSAS tabular or Multi-Dim solution also with this dynamic approach.
Its a kind of Interactive reporting. I know this can be done easily with SSRS. But self servicing wont be available there.
Thank You
May 6, 2015 at 4:50 am
Personally I think the easiest option is to use Power Query.
You can check the blog of Chris Webb on how to make functions inside Power Query.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 12, 2015 at 10:36 am
I used the parameters in PowerQuery using the below link. It is really what I want but Its not working on SharePoint BI site. I want this to be used by all users by getting on to BI site.
http://blog.oraylis.de/2013/05/using-dynamic-parameter-values-in-power-query-queries/
Thank You
May 12, 2015 at 2:18 pm
VRT (5/12/2015)
I used the parameters in PowerQuery using the below link. It is really what I want but Its not working on SharePoint BI site. I want this to be used by all users by getting on to BI site.http://blog.oraylis.de/2013/05/using-dynamic-parameter-values-in-power-query-queries/
Ah yes, Power Query is currently not supported in SharePoint on premises.
Their alternative is to use the Power BI site (which is actually just an app in SharePoint Online).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 12, 2015 at 2:24 pm
PowerBI site is what I think I am using now. It only has PowerPivot gallery and we can really schedule the PowerPivot reports here. also we can create performance Point reports.
Thank You
May 12, 2015 at 2:48 pm
VRT (5/12/2015)
PowerBI site is what I think I am using now. It only has PowerPivot gallery and we can really schedule the PowerPivot reports here. also we can create performance Point reports.
No, that is just a regular BI site in SharePoint.
I'm talking about the Power BI site in Office 365.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply