Forum Discussion
Continued ContributorDownload report with Power BI Service live connection?
Hi,
I came across this post as I had the same problem myself, and have found a fairly straightforward solution to it.
I found this blog post here about SQL Server live query, but I tried it and the same can be applied for Power BI service dataset as well:
Essentially you need to:
1. Download the PBIX file (which will be a full PBIX file with a copy of the dataset)
2. Open Query Editor and delete absolutely everything, then close and apply. Expect to see errors in all of your visuals, but don't worry.
3. Choose Get Data and connect to the desired PBI service dataset. (Make sure that there aren't any tables left or PBI will say that there is an existing dataset - even though I had deleted all queries in the Query Editor I still had one parameter table left which I had to delete from the Tables view.)
If all goes well your visuals will all work correctly and you will be connected to your PBI service dataset.
Hi,
I came across this post as I had the same problem myself, and have found a fairly straightforward solution to it.
I found this blog post here about SQL Server live query, but I tried it and the same can be applied for Power BI service dataset as well:
Essentially you need to:
1. Download the PBIX file (which will be a full PBIX file with a copy of the dataset)
2. Open Query Editor and delete absolutely everything, then close and apply. Expect to see errors in all of your visuals, but don't worry.
3. Choose Get Data and connect to the desired PBI service dataset. (Make sure that there aren't any tables left or PBI will say that there is an existing dataset - even though I had deleted all queries in the Query Editor I still had one parameter table left which I had to delete from the Tables view.)
If all goes well your visuals will all work correctly and you will be connected to your PBI service dataset.
Helper II have a workbook with an open-ended query so the data refresh will always pull in more data. When I publish it to the Power BI Service members of the workspace can refresh but when I sent a copy of the workbook to a user, the refresh threw an error because the user isn't whitelisted for our SQL Server. Is the only way around that through published workspaces?