cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

undefined

In my Power BI Report, my dataset is coming from 2 different data source, OneDrive & SQL Analysis Services. In schedule refresh, how can I refresh these 2 data data source independently, so that even if Analysis Services fails, OneDrive Data can get refreshed

5 REPLIES 5
Highlighted
Super User IV
Super User IV

Re: undefined

@Yash_Ag I'm not sure there is a way to do that, @ImkeF @edhans ?


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Microsoft
Microsoft

Re: undefined

Hi @Yash_Ag ,

 

I found no solution to refresh data source independently in one dataset. Once there is a problem with one of the data sources, the refresh will fail and none of the data sources will be refreshed.

 

As a workaround, I suggest you use Composite mode in your dataset. Composite mode can mix Import and DirectQuery modes, or integrate multiple DirectQuery data sources. For more details, please refer to https://docs.microsoft.com/en-us/power-bi/connect-data/service-dataset-modes-understand

 

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

 

Best Regards,

Dedmon Dai

Highlighted
Helper I
Helper I

Re: undefined

@v-deddai1-msftThanks for reply, it has helped me to a new perspective for this issue.

 

I have read the article, from the article I came to understand that to create a composite model, direct query is required. Now, the issue is that for connecting to SQL Analysis Services, I have to use SQL Server Analysis Services database connector of Power BI Dekstop, which only have Import or Connect Live, connection options, how can I use direct query using this connector

Highlighted
Super User III
Super User III

Re: undefined

@Yash_Ag - as you've discovered, refresh is all or nothing. You cannot have different sources refreshed on different schedules, and when one source fails, the entire refresh is halted.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Highlighted
Microsoft
Microsoft

Re: undefined

Hi @Yash_Ag ,

 

Unfortunately, SSAS does not support DQ mode, as edhans said, You cannot have different sources refreshed on different schedules, and when one source fails, the entire refresh is halted. I can't think of anything other than putting these two data sources in different datasets.

 

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

 

Best Regards,

Dedmon Dai

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

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

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!