Couldn't load the data for this visual (The exception was raised by the IDbCommand interface)

[milosdjordjevic]

Hi,

I created a report and dataset on the power bi desktop (last version). There everything is fine. When I published on https://app.powerbi.com/. I can not see my matrix table. I can see if I create a regular table, but when I create a matrix table I got this. I am using PostgreSQL on Azure, and my query is ultra simple. But when I create a matrix always is the same.

thanks,

Milos

[v-xiaoyan-msft]

Hi @milosdjordjevic ,

We are notified that this issue has been fixed, please try again to see if it is back to normal, thank you.

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[v-xiaoyan-msft · Accepted solution]

Hi @milosdjordjevic ,

Update : This issue has been fixed,thanks!

-------------------------------------------------------------------------------------

This issue has been confirmed as a known issue internally.(Internal ICM ID: 261924113)

Please be patient to wait for fixing. If there is any news, I will update it here.

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[bcdobbs]

Realise your Postgre sql is running in azure but do you have any on prem

data sources as well (flat files) that are requiring it to use a gateway? If so check if the gateway has been updated. (You should be able to see if you go to manage gateways in the power bi service)

[milosdjordjevic]

I am using Azure Database for PostgreSQL, and I have this for gateway:
Gateway connection

You don't need a gateway for this dataset, because all of its data sources are in the cloud, but you can use a gateway for enhanced control over how you connect. Learn more

[milosdjordjevic]

More info:

• Activity ID6fb2cc0b-ee07-454c-8488-94e3938d4502
• Request ID8220517b-03ed-4630-99e0-dc5f91aa2088
• Correlation ID10b14610-e553-d948-5c45-383f979e8673
• TimeThu Dec 30 2021 20:32:50 GMT+0100 (Central European Standard Time)
• Service version13.0.17333.45
• Client version2112.2.09063-train
• Cluster URIhttps://wabi-north-europe-f-primary-redirect.analysis.windows.net/