Forum Discussion

AndrewTobin's avatar
AndrewTobin
Frequent Visitor
6 years ago

Power BI Report Server Data Sources and Scheduled Refresh

I'm having several problems with Power BI Report Server that I hope someone can help with. When I first uploaded my model, the rendered page was completely blank, and when I went to the Settings to ...
data sources
Report Server
scheduled refresh
AndrewTobin's avatar
AndrewTobin
Frequent Visitor
6 years ago

So, while that seems to solve it temporarily - even if you download the file back from the server the next time you upload it again it switches back to DirectQuery.

 

Am I just doing this completely wrong? I really need this to refresh and short of re-developing a huge solution from scratch again, I can't think of anything to do.  And there's no guarantee that would solve it either.

robertjordanmmc's avatar
robertjordanmmc
Frequent Visitor
6 years ago

Here is how I was able to resolve this issue:

 

export Report as [reportName].pbit (can use .pbix as well, just smaller)

rename [reportName].pbit to [reportName].zip

extract all

edit "DataModelSchema" with notepad

update "defaultMode": "directQuery", to "defaultMode": "import",

Highlight all files, Right Click-> Send to -> Compressed (zipped) folder

rename resulting zip to [reportName].pbit

Now when it is deployed, it no longer has any issues. Re-downloading should now reflect the fix.