Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Big Query refresh error in Power BI Service

Hello experts,   I'm connected to a view in BQ which refreshes normally through PBI desktop, but when publishing dataset to PBI service it gives this error: Data source error {"error":{"code":"DM...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Xiaoxin,

     

    I was able to fix it by removing the appended query step in Power BI and appending the data in Big Query before pulling it into Power BI.

     

    Thank you,

    M

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Well, it doesn't like something in your VU_Budget_Tracker_AGG table. Other than that, it is a mystery.

 

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".