Cannot connect to model in Power BI service issue

[hale]

Hi all,

I have this issue today trying to open a report from Power BI Desktop then I notice all my current reports in service are also having the same issue.
Anyone have any idea what this error means?

[v-jianboli-msft]

Hi @hale ,

Possible reasons for the above error are.
1. Please check if the credentials connected to the data source are correct, try to remove the original credentials and reconnect to the data source.
2. Please check if the problem is with the version of Power BI Desktop, try to use the latest or previous version to see if the error exists.
3. Check if the dataset uses RLS. If it uses RLS, try to remove it or give the user the corresponding data access rights.

4. The workspace in which the dataset resides is a V1 Workspace. For V1 workspace or classic workspace, only members of that workspace build reports on your dataset. If the dataset's build permission is explicitly added via methods mentioned here, the dataset would throw an error like above.

For more details, please refer to:

Unable to connect to Power BI Service datasets fro... - Microsoft Power BI Community  

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[hale · Accepted solution]

Thanks for reply.

I just spent the whole day fixing this issue and for my case, the culprit was 2 KPIs created using tabular editor.
Once I remove those, the dataset can be accessed normally. Also those 2 KPIs were created long time ago (3-4 months) and been in used without any issue. There must be an update in Power BI service today and that update doesnt allow those KPIs set up anymore.

Anyway, those suggestions above were absolutely right and worth checking. I even uninstalled the Power BI Desktop and re-installed again. Im glad I fixed it now but also exhausted with all of the things I tried today. The worst thing is I had a demo for stake holders today and had to re-schedule it. What a day, Im considering my career choices right now haha