cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ROYMMM
Frequent Visitor

Refreshes fail when using combined models with PBI Datasets

Hi,

 

I'm working on a report where I combine several PowerBI datasets (via Direct Query) and additional imported tables. This all works fine in Power BI Dekstop. I can refresh the data for the imported tables without any issue. But as soon as I publish the dataset and try to refresh the imported tables via Power BI Service, it flat out fails. It keeps coming back with vague errors about wrong credentials. I litterally tried everything, (i.e. reset the credentials, privacy levels, etc.) but nothing works and I'm 100% sure the credentials are correct.

 

Does anyone have an answer to this?

 

Thanks.

 

Regards,

Maarten

1 ACCEPTED SOLUTION
aj1973
Community Champion
Community Champion

Hi you can't refresh reports in the service with direct Query mode from multiple sources

aj1973_0-1616173141535.png

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

1 REPLY 1
aj1973
Community Champion
Community Champion

Hi you can't refresh reports in the service with direct Query mode from multiple sources

aj1973_0-1616173141535.png

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!