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
Foton83
Frequent Visitor

Refresh data from desktop with Python

Hello everyone,
I have such a problem- I have a script that draws data from the Internet. The way of action is very simple. The script downloads data from the address, e.g." https://123.abc.com/1000". Where by changing the last "1000" element I can move on many pages, e.g. "https://123.abc.com/1002". But to do this I have to enter the editing of the M Power Query code and I would like to do it from the Power Bi Desktop position, e.g. with some icon after pressing which the window would be displayed where I would give the end of the website address. Does this solution exist?

 

 

1 ACCEPTED SOLUTION
Foton83
Frequent Visitor

Hello,

I found a solution. Below I paste the link from the Microsoft website:

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters 

View solution in original post

3 REPLIES 3
Foton83
Frequent Visitor

Hello,

I found a solution. Below I paste the link from the Microsoft website:

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters 

amitchandak
Super User
Super User

Hello @amitchandak ,

Yes, I have a parameter in Power Query, but I need a link to this parameter from Power Bi Desktop, without editing Power Query. As I described I need to change this parameter by calling a window , where I type the end of the address press enter and the data will fetch itself. Alternatively, it would be best for the parameter to be linked to a visualization( table) in Power Bi Desktop.

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.