How can I make a Power BI semantic model not demand the presence of a data gateway to get data from the web?
I created a Power BI report that collects data from:
- a MySQL database (located on the external server)
- a webpage (currency exchange rate table)
When everything worked fine on the Power BI Desktop, I published a semantic model and report on My workspace and tried to refresh it. Refreshes fail!
The failure was the "unavailability of the data gateway (personal mode)". That was correct, as the data gateway (personal mode) was not running on my laptop. But note! Both data sources are from the cloud! So, no data gateway is necessary.
I experimented. I removed the connection to a web page and left only the MySQL connection — no problem! When I reintroduced a connection to a webpage, a semantic model expected data gateway again.
For a test, I installed the data gateway (personal mode), and when it runs, the semantic model refreshes. However, I do not want to keep my laptop running whenever a refresh is expected.
How can I make the semantic model not demand the presence of an unnecessary data gateway?
The setting page of the semantic model looks like this:
Finally, I managed to get rid of the annoying problem.
The problem was that the working folder in which I had saved *.pbix files locally (before publishing them to the Power BI service) was synchronized with the OneDrive cloud. This most likely creates a conflict with the Power BI automatic update mechanism.
I did the following:
- Opened a "faulty" report on my local machine with Power BI Desktop
- I Saved it as... again in a local folder, which is not backed by OneDrive!!! Cloud synchronization mechanism
- Published it then to My workspace
- And it start to work, without complaining on lack of data gateway!
- Replicate SUM with COUNTIF in Power BI
- Aggregate overlapping time intervals, calculate outage times, improve performance
- Strange behaviour of Functions with Dates
- How to count if your column has the same values on another column in separate related table
- How do I create a complicated aggregated measure in Power Bi for use on a dashboard?
- Create a column that counts all "Y" in all other columns for each row in Power BI
- Power BI - Count occurrences in IF statement correct per day, wrong over time
- Power BI get the last NR using DAX
- In Power Query, how do I calculate total time worked over multiple days based on work shift patterns and excluding weekends?
- In Power BI, how to sum a column that is filtered by DAX measure?
- DAX For duplicated values in first column, check if there are duplicated values in second column
- Dax measure error in a table with 100 rows but not in one with 50 rows
- Power Bi Matrix not calculating "Total" properly when creating DAX measure with "if" statement
- Calculate Sub Total as Row
- PowerBI - Get 2 tables from 1 table and subtract them
- POWERBI - DAX - RunningTotal
- Count specific values across multiple columns based on data in another column
- Identifying the max in a group using PowerQuery
- Need to calculate distinct count and percentage in a single row using power bi dax
- Power BI Relative Date Slicer
- Comparing different version's values within same column - Power BI
- How can I make a Power BI semantic model not demand the presence of a data gateway to get data from the web?
- Quick Measure Error: "Only Power BI-provided date hierarchies are supported"
- How to apply RLS to other dimensions when using the static RLS approach?
- How to join columns from different tables and insert a calculated column in PowerBI / Power Query
- What does it mean by Power BI report references a row with RLS?
- Power BI - Dynamically generate queries
- Getting the next value of the same user if the type is "no type"
- DAX calculate relatively last month, quarter and year
- Add a new column from value that is stored in a list of cell of the table