Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Stefan_S
Regular Visitor

Using getway with Datasets witch have one excel query

Hello,

 

I have used my getway for a SQL-Query (CRM) succesful to update a Dataset.

Now I have add a local Excel-Sheet to this Dataset. (I don´t won´t Update this excel-sheet).

After I upload this Dataset to the Power BI Service, the connection to the getway faild.

I´m aware I can´t update the Excel, but the update of the SQL-Query also failed.

How I can set the Excel-Querry to "no update", so the getway will work for the SQL-querry again.

 

Thanks for your support.

Stefan

1 ACCEPTED SOLUTION

I find a way to solve my issue.

I create a new table and copy-past the information into the empty table.

https://www.sqlbi.com/articles/create-static-tables-in-dax-using-the-datatable-function/

 

Best

Stefan

 

View solution in original post

12 REPLIES 12

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors