Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
So I didnt do any thing special. I just connect to TWO powerbi Dataset and add excel file.
Create relationships. But when i publish im getting the error of
Also RELATED formula is not working. even i have a Many is to 1 relationship.
Team,
I am having same exact issue today
Jim
jpierzchalaAdvocate I
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.
- jeroenterheerdt
this is something we're looking at to change, it is not easy though.
- jeroenterheerdt
you need build permissions on the full chain at the moment.
- jpierzchala
I'm not entirely sure what do you mean by that.
My experience is that if you have a build permission to a dataset you can build reports on top of this dataset (using live connection mode) and publish to service even if you're not a member of the workspace, the dataset resides in.
However, the moment you change to DirectQuery mode (the "make changes to this model" option) publishing no longer works due to the exception above
