Forum Discussion
Helper IPaginated Reporting / Power BI Premium Per User License
Hello Amerikaner !
This works fine for me, I have worked with my power BI service hosted datsets connected live with a Premium per User workspace. It works the same way it works with Power Bi Desktop ,I only had to enable XMLA Read Write on my Power BI tenant .
I am able to use DataSOurce -->Add Power Bi Datset Connection and it works seemlessly from there.
And If you want to use your local power BI dataset, then please open up your PBix file that contains the dataset on local and then copy the port name from DAX studio or local folder (you may find that on web how to get that) . Now use this to connect to "SQL Server Analysis Services" connection :
You are good to use your paginated with this datasource creating the datsets on this ! Only issue is that you will need to keep your PBIX running and also if you choose to close it /restart machine then change the datsource to new port/select new DB that appears on new Pbix open.
Thanks!
Abhinav Singh
Solution SageAmerikaner Glad that could help!
You may try runnig profiler on your dataset to see if the actual error is logged. The steps to run profiler are my article below in case you wish to debug this further! Maybe if you are able to post the actual error from the trace , the forum could help!
https://www.linkedin.com/pulse/run-profiler-power-bi-live-datasets-paginated-reports-abhinav-singh/
Helper IHi Abhinav,
Thanks again for your quick response. First, I went into my Data Source Credentials in the Premium Workspace, noticed invalid credentials and updated (see attached).
Second, I sourced the Workspace Connection from my Premium Workspace.
Third, I opened SQL Server Profiler, File/New Trace and tried to connect to the Premium Workspace. See attached.
As noted above, I was unsuccesssful.
- AbhiSSRS
Hmm... This may be teh same reason that MS is investigating.
Just to confirm you did select dataset in options?
- Amerikaner
I just now selected options and selected both default and then browse server.
Unsuccessful.
- AbhiSSRS
Hmm... Lets leave it to MS then ! Please do post here what they find when this is resolved! 🙂
Thanks!