Forum Discussion

JaJa1313's avatar
JaJa1313
New Member
2 years ago

Changing SQL query of live PowerBI dataset

Good day everyone,   Today when working on a pbix file I saw that I could no longer edit the import SQL queries of my datasets. I then saw the following message in the bottom right: N...
Need Help
ray_aramburo's avatar
ray_aramburo
Icon for Super User rankSuper User
2 years ago

You need to change your connection method then. It seems you are connected directly to a Power BI dataset instead of a database you can import/read with SQL. Go to Power Query and check your connections and sources there. 

JaJa1313's avatar
JaJa1313
New Member
2 years ago

When opening Power Query it requires me to create a local model. I can only delete the live PowerBI dataset, but cannot select advanced editor and there are no active queries so I cannot edit the queries.

 

I there a way to view the SQL queries that the PBI dataset uses to update/refresh online? If I can delete the connection, it would assist if I can view the Sql queries as the pbix was built by another person.

  • ray_aramburo's avatar
    ray_aramburo
    Icon for Super User rankSuper User
    2 years ago

    From the file that has the live connection no; you need to request the original developer for the file that has the data model or request read permissions to that dataset and then downloading a copy of the .pbix file.