Forum Discussion
Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
I'm having the exactly same issue on my end. I believe it is related to problems with build permission. The publish work correctly when you connnect to datasets located in a workspace you are member of. The above exception occurs when you try to publish a report which utilizes Direct Query connection to a dataset you only have build permission to but are not a member of a workspace it resides in.
I have a support ticket opened on this but it is progressing painfully slow.
Yes, I am having the same issue. The concern for me is that most report developers are not going to have build / member permissions on centrally managed datasets produced by IT. We should be able to take a Power BI dataset (read only) via live connection and combine it with local data (spreadsheet). I cannot do that in the preview version.
- jeroenterheerdt5 years agoMicrosoft Employee
this is something we're looking at to change, it is not easy though.