Forum Discussion

sandeepiiit's avatar
sandeepiiit
Frequent Visitor
9 years ago
Solved

Unable to setup a refresh schedule

I made a report using PowerBI Desktop that connects to different SQL Azure Databases using "Import" mode. (Import mode because DirectQuery mode is not supported for more than one database). I publish...
Need Help
  • sandeepiiit's avatar
    sandeepiiit
    9 years ago

    Now I am able to schedule refreshes, even without a gateway. The issue was that the credentials to one of my sources was wrong.

     

    To summarize:

    1. As everyone mentioned, using multiple sources is not supported in DirectQuery mode and Import mode is the only way.

    2. Refresh scheduling DOES work for Import mode as well. No gateway is needed (for SQL Azure databases).

     

sandeepiiit's avatar
sandeepiiit
Frequent Visitor
9 years ago

Thanks for the reply.

Is it possible to use "DirectQuery" with two data sources? (both sources are SQL Azure dbs). I was actually forced to use import mode when I added the second source, because it complained that DirectQuery can't allow multiple sources.

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi sandeepiiit,

 

>>Is it possible to use "DirectQuery" with two data sources?

Current "direct query" not support connect to multiple datasource, even if there are in the same server.
If you want to connect to multiple datasource, you need to switch the connect mode to import.

 

There are currently a few limitations to using DirectQuery:

  • All tables must come from a single database

For more detail abou use direct query, you can refer to follow link:

Use DirectQuery in Power BI Desktop

 

In addition, you can also send your requirement to ideas.

 

Regards,

Xiaoxin Sheng