Forum Discussion
Visuals not loading on Service with DirectQuery connection to a Power BI dataset (AAS)
Hi Anonymous
Finally it turns out that my company is blocking the possibility to use DirectQuery for Power BI datasets because this is a feature in preview so there could be updates to come which would make my work useless...
Do you know when this feature will be accepted as an official one ?
Regards,
Cado
Hi Anonymous ,
Could you please tell me that is your strorage mode "Direct Query" in the bottom right corner of the screen of your Power BI desktop?
Have you check your dataset settings and gateway managements if they are configured correctly?
Best Regards,
Yuna
Hi Anonymous
Yes I have the DirectQuery mode in the bottom right corner of my Power BI desktop.
When I go the the settings of the dataset on PBI Service it says that a gateway is not needed because all data sources are in the cloud.
My Oauth2 credentials are okay too.
Is there an other setting I forgot ?
Regards,
Cado
Hi Anonymous ,
Thanks for your reply.
Can the related report of Power BI Dataset used as a data source be successfully opened? Are you the owner of this Power BI dataset?
Does it need to reset credentials?
Best Regards,
Yuna
Anonymous
I am the owner of the local model of the dataset (created thanks to DirectQuery mode) but I'm not the owner of the Power BI dataset used as data source.
I just replaced the "none" by "organizational" in the credentials setting and now I have the visuals displayed in Service but the data is stil not accessible it gives me this error
When I click "see details" it says "impossible to extract data from this visual"
I tried to connect on desktop to this dataset and it returns this error
Regards,
Cado
Hi Anonymous
Finally it turns out that my company is blocking the possibility to use DirectQuery for Power BI datasets because this is a feature in preview so there could be updates to come which would make my work useless...
Do you know when this feature will be accepted as an official one ?
Regards,
Cado