Forum Discussion

terry_levan's avatar
terry_levan
Regular Visitor
7 years ago

Unable to save .PBIX file containing SQL Server Direct Query and a Calendar Table

Hi! I am new to the forum so I apologize up front. I have created a report with a Direct Query to a SQL Server database. I created a couple visuals and save the file. As soon as I added a calendar ...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi terry_levan 

You use Power BI Desktop and happen to this error, right?

If so, first, please note that time intellignece function is not supported for use in DirectQuery mode. For more information about limitations in DirectQuery models, seehttps://go.microsoft.com/fwlink/?LinkId=219172.

 

We just published the latest 4/21/2019 release (2.68.5432.841), can you try updating to the latest to see if that resolves your issue:

https://www.microsoft.com/en-us/download/details.aspx?id=45331

 

In addition, if you use Power bi report server and see this error, please have a look at this article.

https://blog.devoworx.net/2019/01/19/missing-save-as-power-bi-report-server-in-power-bi-desktop/

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Onkareshwar's avatar
Onkareshwar
New Member
5 years ago

Thanks terry_levan for your response, however your shared document is much helpful for me in my case.
I found the workaround for this issue. I opned the new Power BI template file and In that i imported the previous saved template usinf File>Import option, then i did the transformation whaterver i need then i am able to save the Template.