Forum Discussion
Change directquery to import error?
You're welcome 🙂
Ah - that explains it then.When you use DirectQuery with Analysis Services or Power BI datasets within a Composite Model (as described here), the tables from the "remote datasets" cannot be switched to Import mode.
The idea of connecting to datasets in this way is that you are connecting to a "model" rather than individual tables, inheriting all features of the remote model, and the tables remain remote and are not imported into the local model.
If you wanted to import a table from an Analysis Services dataset, you would need to instead use the Analysis Services connector and select Import (Get Data > Analysis Services and select Import).
This should work with any Analysis Services dataset, but would only work with Power BI datasets with XMLA endpoints enabled (requiring Premium).
However it is generally considered better to connect to the underlying data source than importing from Analysis Services, but there may be specific reasons you need to do it this way.
Regards,
Owen
On the face of it that's odd. Normally DirectQuery can be changed to Import but not vice versa.
I couldn't find anything in the documentation to explain this behaviour.
- What is the current DirectQuery source?
- Could you provide more detail on the data source for this table and other tables in the model?
- Are all tables currently DirectQuery?
- Is there anything notable/unusual about the current data model?
Thanks for the assistance. I connected to a live dataset (live connection type) and then turned it into a directquery and then I am trying to turn this into a Import.
The source: Well unfortunately I don't have much details as I didn't create the data/
I can confirm that all of the tables are directquery.
Data source type: SQL Server Analysis Services
Can't tell anything strange - it's a star scheme with a calendar and measures table
You're welcome 🙂
Ah - that explains it then.When you use DirectQuery with Analysis Services or Power BI datasets within a Composite Model (as described here), the tables from the "remote datasets" cannot be switched to Import mode.
The idea of connecting to datasets in this way is that you are connecting to a "model" rather than individual tables, inheriting all features of the remote model, and the tables remain remote and are not imported into the local model.
If you wanted to import a table from an Analysis Services dataset, you would need to instead use the Analysis Services connector and select Import (Get Data > Analysis Services and select Import).
This should work with any Analysis Services dataset, but would only work with Power BI datasets with XMLA endpoints enabled (requiring Premium).
However it is generally considered better to connect to the underlying data source than importing from Analysis Services, but there may be specific reasons you need to do it this way.
Regards,
Owen
Thanks, I tried it and got this error message.
Any idea what this means?
I need to change the connectivity from Direct Query to Import.
Because when I publish Power BI report in Power BI servises, viewers can not View it.
Any other options?
