Forum Discussion
Solution: Changing datasource from Import to Direct Query -> SUCCESS
Hi odegarun,
First, thanks for your sharing.:smileyhappy:
As mike_honey mentioned, I'd like to suggest your submit this requirement ideas to get the official support for this solution.
Since you are modify and replace internal files, I'm not so sure if your operation has caused any hidden broken of the source file. It may caused the broken your data and hard to troubleshooting and recover the losses
Regards,
Xiaoxin Sheng
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
Here's the Idea:
Please vote and comment if you would like to see this function added to Power BI Desktop.
