Forum Discussion

odegarun's avatar
odegarun
Advocate II
8 years ago

Solution: Changing datasource from Import to Direct Query -> SUCCESS

Hi all   I recently wanted to change the datasource from Import to Live Query using the "Power BI service" and had a good lookaround without turning up much other than "you can not"...   However ...
Tips and Tricks
odegarun's avatar
odegarun
Advocate II
8 years ago

submitted, thanks for the tip.

 

I can not see that my method has caused any problems for me, not yet atleast ;-)

Changed the datasource in this way on a pbix having a import of roughly 43.000 rows (27 columns) to using Power BI services connecting the pbix to a published pbix which had the same import (among others (totalling about 30 tables with roughly 300k rows and numerous columns distributed on the tables) ). I simply added the missing table required to my datasources and re-published my master report (it has about 16 pages with a lot of visual on each page)...

 

In this way I was able to publish the pbix with a connection to the Power BI services once, and it is updated whenever I publish my master report. :-D

 

brgds

odegarun