Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I have a Power BI report (let's call this Master) which connects to SQL to get it's data. Gateway all setup and refreshes daily. I also have a second Power Power BI report (let's call this User) which uses Master as it's data source, connecting using analysis services (Import Mode) with Microsoft Account as authentication. I publish this report and all works fine. I'd expect that when Master refreshes daily, User should just update too but this is not happening. If I look at the dataset for User you can't configure anything to do with refreshes or gateways (says I don't need one as the source is in the cloud). If I try a manual refresh I get the following error. Any help would be appreciated.
Solved! Go to Solution.
In dataset settings -> Data source credentials -> Oauth2 and login with the applicable credentials
In dataset settings -> Data source credentials -> Oauth2 and login with the applicable credentials
Top man! You win the prize today, thanks for your help.