search

microsoft / powercat-automation-kit

Other
69 stars 18 forks source link

[Automation - BUG] Power BI Dashboard is not loading properly (This query does not have any columns with the supported data types. It will be disabled from being loaded to the model.) #303

Open KoteshMCGit opened 1 year ago

KoteshMCGit commented 1 year ago

Describe the issue

Recently observed that Power BI dash board is not loading and getting below error, when it is exported / save as power BI Template after May 15 or latest version of Power BI desktop.

Error Details: This query does not have any columns with the supported data types. It will be disabled from being loaded to the model.

Because of this error, dashboard is not loading data / not loading relationships/measures.

Below Error is coming while loading model

image

Expected Behavior

Without any error Power BI dashboard should load properly with using of latest version of Power BI Desktop

What component are you experiencing the issue with?

Automation Project

What solution version are you using?

May 2023

What app or flow are you having the issue with?

Power BI Dashboard

Steps To Reproduce

Install Latest Power BI Dashboard

  1. Open any old version of Power BI Template ( *.PBIT) file and configure with valid data verse connection.
  2. Save as with *.PBIT file
  3. Try to export as Power BI Template
  4. Open newly exported / saved as template and configure with valid data verse connection.

while loading of entity mode, you are getting the same error.

Anything else?

No response

AB#486

KoteshMCGit commented 1 year ago

It has been fixed and working fine now.