Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Microsoft EmployeeAre you sure you did not change anything between today and yesterday? Different dataset? Different workspace?
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
the relationship that RELATED is not working on is that between source groups or within the same source group?