Forum Discussion

TiaanRossouw's avatar
TiaanRossouw
Frequent Visitor
4 years ago
Solved

Permissions needed to share a dataset

I have created 3 reports. The first (let's call it report A) contains all the queries that I need for all 3 reports. So I decided to publish report A, and then use it's dataset as the source on repor...
Need Help
  • TiaanRossouw's avatar
    TiaanRossouw
    4 years ago

    I found the problem. I tried accessing another datasource before using the dataset directly, and Power BI won't "forget" that. The datasets in the reports where the permissions where not working correctly, were defined as DirectQuery, and not "Connected live to the Power BI dataset". I re-created the report and made sure that I only add a single datasource (the connection to the PBI dataset). Works perfectly now.

TiaanRossouw's avatar
TiaanRossouw
Frequent Visitor
4 years ago

I found the problem. I tried accessing another datasource before using the dataset directly, and Power BI won't "forget" that. The datasets in the reports where the permissions where not working correctly, were defined as DirectQuery, and not "Connected live to the Power BI dataset". I re-created the report and made sure that I only add a single datasource (the connection to the PBI dataset). Works perfectly now.