Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Yes Im sure i logged in.
I tried it yesterday and it works. today im getting this error.
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.
- jeroenterheerdt
the relationship that RELATED is not working on is that between source groups or within the same source group?